﻿CREATE TABLE [dbo].[Stock_In] (
    [Pno]     INT        NOT NULL,
    [Gno]     INT        NOT NULL,
    [Indate]  NCHAR (10) NULL,
    [Inprice] REAL       NULL,
    [Innum]   INT        NULL,
    PRIMARY KEY CLUSTERED ([Pno] ASC, [Gno] ASC),
    FOREIGN KEY ([Gno]) REFERENCES [dbo].[Goods] ([Gno]) ON DELETE CASCADE,
    FOREIGN KEY ([Pno]) REFERENCES [dbo].[Provider] ([Pno]) ON DELETE CASCADE
);

